Verifying Your Integration

After all the files have been configured, you can verify your integration using either of the following.

Identify Encrypted Tablespaces

SELECT TABLE_SCHEMA, TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE CREATE_OPTIONS LIKE '%ENCRYPTION%';

Rotate Master Key

The master encryption key should be rotated periodically or whenever you suspect that the key has been compromised.

To rotate the master key:

1. Run the following query:

   ALTER INSTANCE ROTATE INNODB MASTER KEY;
   

2. Check the server records on the CipherTrust Manager to verify the status of the operation.